<%
Dim pagesize,curpage,Special_rs
pagesize=30 '设置每页显示 3的倍数
If Request.QueryString("page")="" or not IsNumeric(Request.QueryString("page")) Then
curpage = 1
Else
curpage = cint(Request.QueryString("page"))
End If
If action="best" Then
sql = "select SpecialID,name,Yuyan,SClassID,SClass,NClass,pic,hits from [ylmv_Special] where isgood=true ORDER BY SpecialID desc"
ElseIf action="hot" Then
sql = "select SpecialID,name,Yuyan,SClassID,SClass,NClass,pic,hits from [ylmv_Special] ORDER BY hits desc"
Else
sql = "select SpecialID,name,Yuyan,SClassID,SClass,NClass,pic,hits from [ylmv_Special] ORDER BY SpecialID desc"
End If
Set Special_rs = Server.CreateObject("ADODB.Recordset")
Special_rs.open sql, conn, 1, 1
If Special_rs.eof Then
Response.Write("还没有专辑呢, 谢谢你的支持!")
End If
Special_rs.pagesize = pagesize
Special_rs.absolutepage = curpage
For i=1 To pagesize
%>
|
专辑名称:<%=Special_rs("name")%>
歌手姓名:<%=Special_rs("NClass")%>
所属语言:<%=Special_rs("Yuyan")%>
.html">进入试听 |
<%
Special_rs.movenext
If Special_rs.eof Then Exit For
Next
%>
|